Columns
Grants
Dependencies
Details
Triggers
Errors
Columns
Grants
Dependencies
Details
Triggers
Errors
COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | COMMENTS | INSERTABLE | UPDATABLE | DELETABLE |
---|---|---|---|---|---|---|---|---|
TIMES_SUBJECT | NUMBER | Yes | null | 22 | null | NO | NO | NO |
INVOLVEMENT_COUNT | NUMBER | Yes | null | 23 | null | NO | NO | NO |
SID | NUMBER(38) | No | null | 1 | null | NO | NO | NO |
OBJ | VARCHAR2(20) | No | null | 2 | null | NO | NO | NO |
NAME_ID | NUMBER(38) | Yes | null | 3 | null | NO | NO | NO |
AGE_YEARS | NUMBER | Yes | null | 4 | null | NO | NO | NO |
SEX | VARCHAR2(4000) | Yes | null | 5 | null | NO | NO | NO |
RACE | VARCHAR2(4000) | Yes | null | 6 | null | NO | NO | NO |
ETHNICITY | VARCHAR2(4000) | Yes | null | 7 | null | NO | NO | NO |
CITIZENSHIP | VARCHAR2(4000) | Yes | null | 8 | null | NO | NO | NO |
OFFICE | VARCHAR2(4000) | Yes | null | 9 | null | NO | NO | NO |
DIVISION_INVOLVEMENT | VARCHAR2(4000) | Yes | null | 10 | null | NO | NO | NO |
EMPLOYEE_TYPE | VARCHAR2(4000) | Yes | null | 11 | null | NO | NO | NO |
EDUCATION | VARCHAR2(4000) | Yes | null | 12 | null | NO | NO | NO |
MIL_SERVICE_COUNTRY | VARCHAR2(108) | Yes | null | 13 | null | NO | NO | NO |
MIL_SERVICE_TYPE | VARCHAR2(4000) | Yes | null | 14 | null | NO | NO | NO |
MIL_SERVICE_RANK | VARCHAR2(100) | Yes | null | 15 | null | NO | NO | NO |
MIL_SERVICE_START_DATE | DATE | Yes | null | 16 | null | NO | NO | NO |
MIL_SERVICE_END_DATE | DATE | Yes | null | 17 | null | NO | NO | NO |
MIL_SERVICE_DISCHARGE | VARCHAR2(4000) | Yes | null | 18 | null | NO | NO | NO |
IS_NGA_EMPLOYEE | VARCHAR2(2) | Yes | null | 19 | null | NO | NO | NO |
CLEARANCE | VARCHAR2(4000) | Yes | null | 20 | null | NO | NO | NO |
PAY_BAND | VARCHAR2(4000) | Yes | null | 21 | null | NO | NO | NO |
PRIVILEGE | GRANTEE | GRANTABLE | GRANTOR | OBJECT_NAME |
---|
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|
References
NAME | VALUE |
---|---|
CREATED | 06-APR-23 |
LAST_DDL_TIME | 05-FEB-25 |
OWNER | QART |
VIEW_NAME | V_MV_PARTICIPANT_INDIV |
TEXT_LENGTH | 7372 |
TEXT | SELECT DISTINCT I.SID, I.OBJ, N.SID AS NAME_ID, ROUND((NVL(I.DOD, SYSDATE) - I.DOB) / 365) AS AGE_YEARS, C.SEX, C.RACE, C.ETHNICITY, Z.CITIZENSHIP, OFF.OFFICE, DIV.DIVISION_INVOLVEMENT, EMP_TYPE.EMPLOYEE_TYPE, E.EDUCATION, CTRY.DISPLAY AS MIL_SERVICE_COUNTRY, SERV_TYPE.DISPLAY AS MIL_SERVICE_TYPE, I.SERVICE_RANK AS MIL_SERVICE_RANK, I.SERVICE_BEGIN_DATE AS MIL_SERVICE_START_DATE, I.SERVICE_END_DATE AS MIL_SERVICE_END_DATE, DISCHARGE_TYPE.DISPLAY AS MIL_SERVICE_DISCHARGE, I.IS_NGA_EMPLOYEE, CLEAR_TYPE.DISPLAY AS CLEARANCE, PAY_BAND.DISPLAY AS PAY_BAND, NVL(T.SUBJECT_COUNT, 0) AS TIMES_SUBJECT, NVL(INV.INVOLVEMENT_COUNT, 0) AS INVOLVEMENT_COUNT FROM MV_PARTIC_INDIV I LEFT JOIN MV_ACM_REF_CTRY CTRY ON I.SERVICE_COUNTRY = CTRY.ISO_3166_1_NUMERIC LEFT JOIN MV_ACM_REFERENCE SERV_TYPE ON I.SERVICE_TYPE = SERV_TYPE.REF_KEY LEFT JOIN MV_ACM_REFERENCE DISCHARGE_TYPE ON I.SERVICE_DISCHARGE_TYPE = DISCHARGE_TYPE.REF_KEY LEFT JOIN MV_ACM_REFERENCE CLEAR_TYPE ON I.CLEARANCE = CLEAR_TYPE.REF_KEY LEFT JOIN MV_ACM_REFERENCE PAY_BAND ON I.PAY_BAND = PAY_BAND.REF_KEY LEFT JOIN MV_PARTIC_NAME N ON I.OBJ = N.OBJ AND N.IS_CURRENT = 'Y' LEFT JOIN ( SELECT DISTINCT INDIV_PARTIC, LAST_VALUE(SEX.DISPLAY) OVER(PARTITION BY INDIV_PARTIC ORDER BY EFFECTIVE_DATE RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING ) AS SEX, LAST_VALUE(RACE.DISPLAY) OVER(PARTITION BY INDIV_PARTIC ORDER BY EFFECTIVE_DATE RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING ) AS RACE, LAST_VALUE(ETH.DISPLAY) OVER(PARTITION BY INDIV_PARTIC ORDER BY EFFECTIVE_DATE RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING ) AS ETHNICITY, LAST_VALUE(HEIGHT) OVER(PARTITION BY INDIV_PARTIC ORDER BY EFFECTIVE_DATE RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING ) AS HEIGHT, LAST_VALUE(WEIGHT) OVER(PARTITION BY INDIV_PARTIC ORDER BY EFFECTIVE_DATE RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING ) AS WEIGHT, LAST_VALUE(HAIR_COLOR) OVER(PARTITION BY INDIV_PARTIC ORDER BY EFFECTIVE_DATE RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING ) AS HAIR_COLOR, LAST_VALUE(EYE_COLOR) OVER(PARTITION BY INDIV_PARTIC ORDER BY EFFECTIVE_DATE RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING ) AS EYE_COLOR, LAST_VALUE(EFFECTIVE_DATE) OVER(PARTITION BY INDIV_PARTIC ORDER BY EFFECTIVE_DATE RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING ) AS EFFECTIVE_DATE FROM MV_PARTIC_INDIV_CHAR MPIC LEFT JOIN MV_ACM_REFERENCE RACE ON RACE.REF_KEY = MPIC.RACE LEFT JOIN MV_ACM_REFERENCE SEX ON SEX.REF_KEY = MPIC.SEX LEFT JOIN MV_ACM_REFERENCE ETH ON ETH.REF_KEY = MPIC.ETHNICITY ) C ON I.SID = C.INDIV_PARTIC LEFT JOIN ( SELECT INDIV_PARTIC, LISTAGG(CTRY.DISPLAY || ' (' || CIT.EFFECTIVE_DATE || ')', ', ') WITHIN GROUP( ORDER BY COUNTRY) AS CITIZENSHIP FROM MV_PARTIC_INDIV_CITIZENSHIP CIT LEFT JOIN MV_ACM_REF_CTRY CTRY ON CTRY.ISO_3166_1_ALPHA_2 = CIT.COUNTRY GROUP BY INDIV_PARTIC ) Z ON I.SID = Z.INDIV_PARTIC LEFT JOIN ( SELECT INDIV_PARTIC, LISTAGG(EDUCATION_LEVEL, ', ') WITHIN GROUP( ORDER BY END_DATE) OVER(PARTITION BY INDIV_PARTIC) AS EDUCATION FROM MV_PARTIC_INDIV_EDUCATION ) E ON I.SID = E.INDIV_PARTIC LEFT JOIN ( SELECT OBJ, LISTAGG(PIOR.DISPLAY, ', ') WITHIN GROUP( ORDER BY PIOR.DISPLAY) OVER(PARTITION BY OBJ) AS OFFICE FROM MV_PARTIC_INDIV_OFFICE PIO LEFT JOIN MV_PARTIC_INDIV_OFFICE_REF PIOR ON PIOR.REF_KEY = PIO.OFFICE ) OFF ON I.OBJ = OFF.OBJ LEFT JOIN ( SELECT LISTAGG(OU.SH_DISPLAY, ';') WITHIN GROUP( ORDER BY SH_DISPLAY) OVER(PARTITION BY MPI.PARTICIPANT) AS DIVISION_INVOLVEMENT, MPI.PARTICIPANT FROM MV_PARTIC_INVOLVEMENT MPI LEFT JOIN V_CURR_OBJ_OWNING_UNIT OU ON OU.OBJ = MPI.OBJ ) DIV ON I.OBJ = DIV.PARTICIPANT LEFT JOIN ( SELECT OBJ, LISTAGG(REF.DISPLAY, ';') WITHIN GROUP( ORDER BY REF.DISPLAY) OVER(PARTITION BY OBJ) AS EMPLOYEE_TYPE FROM MV_PARTIC_INDIV_OFFICE PIO LEFT JOIN MV_ACM_REFERENCE REF ON REF.REF_KEY = PIO.EMPLOYEE_TYPE ) EMP_TYPE ON I.OBJ = EMP_TYPE.OBJ LEFT JOIN ( SELECT PARTICIPANT, COUNT(1) SUBJECT_COUNT FROM MV_PARTIC_INVOLVEMENT MPI WHERE INVOLVEMENT_ROLE IN ( SELECT SID FROM MV_PARTIC_ROLE_TYPE WHERE CODE = 'SUBJECT' ) GROUP BY PARTICIPANT ) T ON I.OBJ = T.PARTICIPANT LEFT JOIN ( SELECT PARTICIPANT, COUNT(1) INVOLVEMENT_COUNT FROM MV_PARTIC_INVOLVEMENT MPI WHERE 1 = 1 GROUP BY PARTICIPANT ) INV ON I.OBJ = INV.PARTICIPANT |
TEXT_VC | SELECT DISTINCT I.SID, I.OBJ, N.SID AS NAME_ID, ROUND((NVL(I.DOD, SYSDATE) - I.DOB) / 365) AS AGE_YEARS, C.SEX, C.RACE, C.ETHNICITY, Z.CITIZENSHIP, OFF.OFFICE, DIV.DIVISION_INVOLVEMENT, EMP_TYPE.EMPLOYEE_TYPE, E.EDUCATION, CTRY.DISPLAY AS MIL_SERVICE_COUNTRY, SERV_TYPE.DISPLAY AS MIL_SERVICE_TYPE, I.SERVICE_RANK AS MIL_SERVICE_RANK, I.SERVICE_BEGIN_DATE AS MIL_SERVICE_START_DATE, I.SERVICE_END_DATE AS MIL_SERVICE_END_DATE, DISCHARGE_TYPE.DISPLAY AS MIL_SERVICE_DISCHARGE, I.IS_NGA_EMPLOYEE, CLEAR_TYPE.DISPLAY AS CLEARANCE, PAY_BAND.DISPLAY AS PAY_BAND, NVL(T.SUBJECT_COUNT, 0) AS TIMES_SUBJECT, NVL(INV.INVOLVEMENT_COUNT, 0) AS INVOLVEMENT_COUNT FROM MV_PARTIC_INDIV I LEFT JOIN MV_ACM_REF_CTRY CTRY ON I.SERVICE_COUNTRY = CTRY.ISO_3166_1_NUMERIC LEFT JOIN MV_ACM_REFERENCE SERV_TYPE ON I.SERVICE_TYPE = SERV_TYPE.REF_KEY LEFT JOIN MV_ACM_REFERENCE DISCHARGE_TYPE ON I.SERVICE_DISCHARGE_TYPE = DISCHARGE_TYPE.REF_KEY LEFT JOIN MV_ACM_REFERENCE CLEAR_TYPE ON I.CLEARANCE = CLEAR_TYPE.REF_KEY LEFT JOIN MV_ACM_REFERENCE PAY_BAND ON I.PAY_BAND = PAY_BAND.REF_KEY LEFT JOIN MV_PARTIC_NAME N ON I.OBJ = N.OBJ AND N.IS_CURRENT = 'Y' LEFT JOIN ( SELECT DISTINCT INDIV_PARTIC, LAST_VALUE(SEX.DISPLAY) OVER(PARTITION BY INDIV_PARTIC ORDER BY EFFECTIVE_DATE RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING ) AS SEX, LAST_VALUE(RACE.DISPLAY) OVER(PARTITION BY INDIV_PARTIC ORDER BY EFFECTIVE_DATE RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING ) AS RACE, LAST_VALUE(ETH.DISPLAY) OVER(PARTITION BY INDIV_PARTIC ORDER BY EFFECTIVE_DATE RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING ) AS ETHNICITY, LAST_VALUE(HEIGHT) OVER(PARTITION BY INDIV_PARTIC ORDER BY EFFECTIVE_DATE RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING ) AS HEIGHT, LAST_VALUE(WEIGHT) OVER(PARTITION BY INDIV_PARTIC ORDER BY EFFECTIVE_DATE RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING ) AS WEIGHT, LAST_VALUE(HAIR_COLOR) OVER(PARTITION BY INDIV_PARTIC ORDER BY EFFECTIVE_DATE RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING ) AS HAIR_COLOR, LAST_VALUE(EYE_COLOR) OVER(PARTITION BY INDIV_PARTIC ORDER BY EFFECTIVE_DATE RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING ) AS EYE_COLOR, LAST_VALUE(EFFECTIVE_DATE) OVER(PARTITION |
TYPE_TEXT_LENGTH | null |
TYPE_TEXT | null |
OID_TEXT_LENGTH | null |
OID_TEXT | null |
VIEW_TYPE_OWNER | null |
VIEW_TYPE | null |
SUPERVIEW_NAME | null |
EDITIONING_VIEW | N |
READ_ONLY | N |
CONTAINER_DATA | N |
BEQUEATH | DEFINER |
ORIGIN_CON_ID | 16 |
DEFAULT_COLLATION | USING_NLS_COMP |
CONTAINERS_DEFAULT | NO |
CONTAINER_MAP | NO |
EXTENDED_DATA_LINK | NO |
EXTENDED_DATA_LINK_MAP | NO |
HAS_SENSITIVE_COLUMN | NO |
ADMIT_NULL | NO |
PDB_LOCAL_ONLY | NO |
DUPLICATED | N |
SHARDED | N |
OWNER | TRIGGER_NAME | TRIGGER_TYPE | TRIGGERING_EVENT | STATUS | OBJECT_ID |
---|
ATTRIBUTE | Line:Position | TEXT |
---|